|
I Compleanni di Oggi |
۰ Oggi non si puo' festeggiare nessuno...
|
|
|
Biblioteca di Non Solo Cuneo
|
| |
Stai leggendo il capitolo:
Classiche parole riservate dai DB
Scritto da
Marco
|
|
|
Attenzione, per accedere alle funzioni
bisogna essere iscritti.
|
| Persona |
Titolo |
Marco
1/10/2004
22.01.00
|
Piu' di una volta mi e' successo che qualche amico/collega perda ore per capire come mai una query non funziona per poi accorgersi il problema era nell'assegnazione di una parola riservata in un campo del db.
In virtu' di cio' eccovi un elenco di parole che normalmente possono essere riservate.
(La lettere singola identifica solo la categoria.. non e' riservata :p)
A
ACCEPT
ACCESS
ACQUIRE
ACTUAL
ADD
ADDRESS
ADVANCING
AFTER
ALL
ALPHABET
ALPHABETIC
ALPHABETIC-LOWER
ALPHABETIC-UPPER
ALPHANUMERIC
ALPHANUMERIC-EDITED
ALSO
ALTER
ALTERNATE
AND
ANY
APPLY
ARE
AREA
AREAS
AS
ASCENDING
ASSIGN
AT
AUTHOR
AUTO
AUTO-HYPHEN-SKIP
AUTO-SKIP
AUTOMATIC
B
BACKGROUND-COLOR
BACKGROUND-COLOUR
BACKWARD
BASIS
BEEP
BEFORE
BEGINNING
BELL
BINARY
BLANK
BLINK
BLOCK
BOTTOM
BY
C
C1
C2
C3
C4
C5
C6
C7
C8
C9
C1
C11
C12
CALL
CANCEL
CBL
CD
CF
CH
CHAIN
CHAINING
CHANGED
CHARACTER
CHARACTERS
CLASS
CLASS-OBJECT
CLOCK-UNITS
CLE
COBOL
CODE
CODE-SET
COL
COLLATING
COLUMN
COM-REG
COMMA
COMMIT
COMMITMENT
COMMON
COMMUNICATION
COMP
COMP-
COMP-1
COMP-2
COMP-3
COMP-4
COMP-5
COMP-6
COMP-X
COMPUTATIONAL
COMPUTATIONAL-
COMPUTATIONAL-1
COMPUTATIONAL-2
COMPUTATIONAL-3
COMPUTATIONAL-4
COMPUTATIONAL-5
COMPUTATIONAL-6
COMPUTATIONAL-X
COMPUTE
CONFIGURATION
CONSOLE
CONTAINS
CONTENT
CONTINUE
CONTROL
CONTROL-AREA
CONTROLS
CONVERT
CONVERTING
COPY
CORE-INDEX
CORR
CORRESPONDING
COUNT
CRT
CRT-UNDER
CSP
CURRENCY
CURRENT-DATE
CURSOR
CYCLE
CYL-INDEX
CYL-OVERFLOW
D
DATA
DATE
DATE-COMPILED
DATE-WRITTEN
DAY
DAY-OF-WEEK
DBCS
DE
DEBUG
DEBUG-CONTENTS
DEBUG-ITEM
DEBUG-LINE
DEBUG-NAME
DEBUG-SUB-1
DEBUG-SUB-2
DEBUG-SUB-3
DEBUGGING
DECIMAL-POINT
DECLARATIVES
DELETE
DELIMITED
DELIMITER
DEPENDING
DESCENDING
DESTINATION
DETAIL
DISABLE
DISK
DISP
DISPLAY
DISPLAY-1
DISPLAY-ST
DIVIDE
DIVISION
DOWN
DROP
DUPLICATES
DYNAMIC
E
ECHO
EGCS
EGI
EJECT
ELSE
EMI
EMPTY-CHECK
ENABLE
END
END-ACCEPT
END-ADD
END-CALL
END-CHAIN
END-COMPUTE
END-DELETE
END-DISPLAY
END-DIVIDE
END-EVALUATE
END-IF
END-INVOKE
END-MULTIPLY
END-OF-PAGE
END-PERFO
END-READ
END-RECEIVE
END-RETURN
END-REWRITE
END-SEARCH
END-START
END-STRING
END-SUBTRACT
END-UNSTRING
END-WRITE
ENDING
ENTER
ENTRY
ENVIRONMENT
EOL
EOP
E
EQUAL
EQUALS
ERASE
ERROR
ESCAPE
ESI
EVALUATE
EVERY
EXAMINE
EXCEEDS
EXCEPTION
EXCESS-3
EXCLUSIVE
EXEC
EXECUTE
EXHIBIT
EXIT
EXTEND
EXTENDED-SEARCH
EXTERNAL
EXTERNALLY- DESCRIBED-KEY
F
FACTORY
FALSE
FD
FH--FCD
FH--KEYDEF
FILE
FILE-CONTROL
FILE-ID
FILE-LIMIT
FILE-LIMITS
FILLER
FINAL
FIRST
FIXED
FOOTING
FOR
FOREGROUND-COLOR
FOREGROUND-COLOUR
FOAT
FROM
FULL
FUNCTION
G
GENERATE
GIVING
GLOBAL
GO
GOBACK
GREATER
GRID
GROUP
H
HEADING
HIGH
HIGH-VALUE
HIGH-VALUES
HIGHLIGHT
I
I-O
I-O-CONTROL
ID
IDENTIFICATION
IF
IGNORE
IN
INDEX
INDEXED
INDIC
INDICATE
INDICATOR
INDICATORS
INHERITING
INITIAL
INITIALIZE
INITIATE
INPUT
INPUT-OUTPUT
INSERT
INSPECT
INSTALLATION
INTO
INVALID
INVOKE
INVOKED
J
JAPANESE
JUST
JUSTIFIED
K
KANJI
KEPT
KEY
KEYBOARD
L
LABEL
LAST
LEADING
LEAVE
LEFT
LEFT-JUSTIFY
LEFTLINE
LENGTH
LENGTH-CHECK
LESS
LIMIT
LIMITS
LIN
LINAGE
LINAGE-COUNTER
LINE
LINE-COUNTER
LINES
LINKAGE
LOCAL-STORAGE
LOCK
LOCKING
LOW
LOW-VALUE
LOW-VALUES
LOWER
LOWLIGHT
M
MANUAL
MASTER-INDEX
MEMORY
MERGE
MESSAGE
METHOD
MODE
MODIFIED
MODULES
MORE-LABELS
MOVE
MULTIPLE
MULTIPLY
N
NAME
NAMED
NATIONAL
NATIONAL-EDITED
NATIVE
NCHAR
NEGATIVE
NEXT
NO
NO-ECHO
NOMINAL
NOT
NOTE
NSTD-REELS
NULL
NULLS
NUMBER
NUMERIC
NUMERIC-EDITED
O
O-FILL
OBJECT
OBJECT-COMPUTER
OBJECT-STORAGE
OCCURS
OF
OFF
OMITTED
ON
OTACKPTR
OPEN
OPTIONAL
OR
ORDER
ORGANIZATION
OTHER
OTHERWISE
OUTPUT
OVERFLOW
OVERLINE
P
PACKED-DECIMAL
PADDING
PAGE
PAGE-COUNTER
PARAGRAPH
PASSWORD
PERFO
PF
PH
PIC
PICTURE
PLUS
POINTER
P
PITION
PITIONING
PITIVE
PREVIOUS
PRINT
PRINT-SWITCH
PRINTER
PRINTER-1
PRINTING
PRIOR
PRIVATE
PROCEDURE
PROCEDURE-POINTER
PROCEDURES
PROCEED
PROCESS
PROCESSING
PROGRAM
PROGRAM-ID
PROMPT
PROTECTED
PUBLIC
PURGE
Q
QUEUE
QUOTE
QUOTES
R
RANDOM
RANGE
RD
READ
READY
RECEIVE
RECORD
RECORD-OVERFLOW
RECORDING
RECORDS
REDEFINES
REEL
REFERENCE
REFERENCES
RELATIVE
RELEASE
RELOAD
REMAINDER
REMARKS
REMOVAL
RENAMES
REORG-CRITERIA
REPEATED
REPLACE
REPLACING
REPORT
REPORTING
REPORTS
REQUIRED
REREAD
RERUN
RESERVE
RESET
RETURN
RETURN-CODE
RETURNING
REVERSE
REVERSE-VIDEO
REVERSED
REWIND
REWRITE
RF
RH
RIGHT
RIGHT-JUSTIFY
ROLLBACK
ROLLING
ROUNDED
RUN
S
S1
S2
S3
S4
S5
SAME
SCREEN
SD
SEARCH
SECTION
SECURE
SECURITY
SEEK
SEGMENT
SEGMENT-LIMIT
SELECT
SELECTIVE
SELF
SELFCLASS
SEND
SENTENCE
SEPARATE
SEQUENCE
SEQUENTIAL
SERVICE
SET
SHIFT-IN
SHIFT-OUT
SIGN
SIZE
SKIP1
SKIP2
SKIP3
SORT
SORT-CONTROL
SORT-CORE-SIZE
SORT-FILE-SIZE
SORT-MERGE
SORT-MESSAGE
SORT-MODE-SIZE
SORT-OPTION
SORT-RETURN
SOURCE
SOURCE-COMPUTER
SPACE
SPACE-FILL
SPACES
SPECIAL-NAMES
STANDARD
STANDARD-1
STANDARD-2
START
STARTING
STATUS
STOP
STORE
STRING
SUB-QUEUE-1
SUB-QUEUE-2
SUB-QUEUE-3
SUBFILE
SUBTRACT
SUM
SUPER
SUPPRESS
SYMBOLIC
SYNC
SYNCHRONIZED
SYSIN
SYSIPT
SYSLST
SYSOUT
SYSPCH
SYSPUNCH
T
TALLYING
TAPE
TEINAL
TEINATE
TEST
TEXT
THAN
THEN
THROUGH
THRU
TIME
TIME-OF-DAY
TIME-OUT
TIMEOUT
TIMES
TITLE
TO
TOP
TOTALED
TOTALING
TRACE
TRACK-AREA
TRACK-LIMIT
TRACKS
TRAILING
TRAILING-SIGN
TRANSACTION
TRANSFO
TRUE
TYPE
TYPEDEF
U
UNDERLINE
UNEQUAL
UNIT
UNLOCK
UNSTRING
UNTIL
UP
UPDATE
UPON
UPPER
UPSI-0
UPSI-1
UPSI-2
UPSI-3
UPSI-4
UPSI-5
UPSI-6
UPSI-7
USAGE
USE
USER
USING
V
VALUE
VALUES
VARIABLE
VARYING
W
WAIT
WHEN
WHEN-COMPILED
WITH
WORDS
WORKING-STORAGE
WRITE
WRITE-ONLY
WRITE-VERIFY
Z
ZERO
ZERO-FILL
ZEROES
ZER
!
+
?
*
/
**
MAGGIORE
MINORE
=
MAGGIORE=
MINORE=
Bye
|
Dragos
23/9/2004
22.11.58
|
dovevi dividere per piattaforma database...
secondo me c'è ne sono di più (se hai fatto riferimento anche ai linguaggi pl/sql e gli altri [perchè c'è pl/sql e poi tutto il resto ;))))])
ciao
dragos
|
Marco
1/10/2004
22.01.00
|
Queste sono le parole da evitare se si vuole pianificare e/o prevedere migrazioni tra i vari DB.
Insomma se le eviti sei sicuro.
Bye
|
|
|
|
.:Premi il tasto "Indietro" per tornare alla pagina precedente.
|
Attenzione, per accedere alle funzioni
bisogna essere iscritti.
|
|
| PENSIERI IN LIBERTA
